MySQL - UPDATE query based on SELECT Query / Обновление самого себя

При возникновении ошибки

<important>Table is specified twice, both as a target for 'UPDATE' and as a separate source for data</important>

How can i update itself in mysql/mariadb

Пример 1: (IN)

UPDATE tbl_category_mark_model_form tbl_1 SET tbl_1.token=NULL WHERE tbl_1.id NOT ( SELECT * FROM ( SELECT id FROM tbl_category_mark_model_form ) t );

Пример 2: (NOT IN)

UPDATE tbl_category_mark_model_form tbl_1 SET tbl_1.token=NULL WHERE tbl_1.id NOT IN ( SELECT * FROM ( SELECT id FROM tbl_category_mark_model_form ) t );

Пример 3: (SUB QUERY)

UPDATE tbl_category_mark_model_form AS tbl_1 INNER JOIN ( SELECT * FROM tbl_category_mark_model_form ) AS tbl_2 ON tbl_1.id = tbl_2.id SET tbl_1.token = CONCAT_WS(':', tbl_2.category_id, tbl_2.form_id, tbl_2.mark_id, tbl_2.model_id) ;

Пример 2: (LEFT JOIN)

UPDATE tbl_category_mark_model_form tbl_1 LEFT JOIN tbl_category_mark_model_form tbl_2 ON tbl_1.id = tbl_2.id SET tbl_2.token = CONCAT_WS(':', tbl_1.category_id, tbl_1.form_id, tbl_1.mark_id, tbl_1.model_id) ;

Пример 4: (INNER JOIN)

UPDATE tbl_category_mark_model_form tbl1 INNER JOIN tbl_category_mark_model_form tbl2 ON tbl1.id = tbl2.id SET tbl2.token = CONCAT_WS(':', tbl1.category_id, tbl1.form_id, tbl1.mark_id, tbl1.model_id) ;