UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBYdiUtmkLahl1O1k9skC6+LRxfoANWCmtfXhBDTcz8='
WHERE
key_id = '7535c0ccbe3a0c7e6765830ab45d1e04dd4239011394f223be15219ce5b3a763'
AND (
token = 'XBYdiUtmkLahl1O1k9skC6+LRxfoANWCmtfXhBDTcz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)