UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HNW0rhffJtrNfpvKil4lmOwCv7LtfWBaYw4auRxnIGA='
WHERE
key_id = '1a9104cc93d6513c609a4746343b463bdabf18cc3e6b34f68fd743c1066e99c9'
AND (
token = 'HNW0rhffJtrNfpvKil4lmOwCv7LtfWBaYw4auRxnIGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)