UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xSqHM8iiTADpsrJuH6CzW5uLpl7ppOWUWVMcmtp7VEE='
WHERE
key_id = '92efdfdce6825a585bfabd4cec44fc38713682d49c9aee185e80e6718503fdb5'
AND (
token = 'xSqHM8iiTADpsrJuH6CzW5uLpl7ppOWUWVMcmtp7VEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)