UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7GJrc432UbGltafqE6M9j++8DnrVRIVY3lf/j8cNMRU='
WHERE
key_id = '4bd78434ce711988c7c5bf6316fe90c7d86ea465d1b4ea4cb49399081fc79298'
AND (
token = '7GJrc432UbGltafqE6M9j++8DnrVRIVY3lf/j8cNMRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)