UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVujxggLigNJ5ExYwzGeGzkapYHsYSuUgdV+fLemlHA='
WHERE
key_id = 'da5cad83e20012dbb420e269883ac577f34afe44740ef46cda0cd4e17e3eb3f5'
AND (
token = 'ZVujxggLigNJ5ExYwzGeGzkapYHsYSuUgdV+fLemlHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)