update hcjob_logs j set j.created_at = from_unixtime(unix_timestamp(j.created_at)-28800), j.updated_at = from_unixtime(unix_timestamp(j.updated_at)-28800) where id < 1458;