UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XnRMFdbrHsJ/9g95s7T+hc0SeBYi967tG9dG+n/FWIU='
WHERE
key_id = 'be7653609b1b3fbae1bd7635f88039ba54aa80bb5e800943e3cbdca802b56414'
AND (
token = 'XnRMFdbrHsJ/9g95s7T+hc0SeBYi967tG9dG+n/FWIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)