UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+vKPbX4NJbU+VitHHWZdr/XlnAO0de/Vc87b2fXHoYU='
WHERE
key_id = '8cc172e926e5afe0e3153d76b42765a4469e27fa99e0e07251dc6b221c6ed0c1'
AND (
token = '+vKPbX4NJbU+VitHHWZdr/XlnAO0de/Vc87b2fXHoYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)