UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cEe9OONMPzXCt7buOvb6YcUG6zC5Ctc2NGwUHVPYqHk='
WHERE
key_id = 'e3036d1774e6afac64ee5b96d01824a1e51f964041328ed8f273812bd208fc27'
AND (
token = 'cEe9OONMPzXCt7buOvb6YcUG6zC5Ctc2NGwUHVPYqHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)