//先查询一下
SELECT
id, DATE_ADD( expire_time, INTERVAL '23:59:59' HOUR_SECOND ) AS newDate
FROM
tenant
WHERE
RIGHT ( expire_time, 8 ) = '00:00:00';
/**更新语句 expire_time 需要更新的字段*/
UPDATE tenant
SET expire_time = DATE_ADD( expire_time, INTERVAL '23:59:59' HOUR_SECOND )
WHERE
RIGHT ( expire_time, 8 ) = '00:00:00';