UPDATE your_table_name
SET created_at =
IF(create_unixtime IS NULL OR create_unixtime = 0,
NULL,
CONVERT_TZ(FROM_UNIXTIME(create_unixtime), '+00:00', '+08:00'));
UPDATE your_table_name
SET created_at =
IF(create_unixtime IS NULL OR create_unixtime = 0,
NULL,
CONVERT_TZ(FROM_UNIXTIME(create_unixtime), '+00:00', '+08:00'));