UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'guFLhrLnCG2Rcz3JMh4M4CzO4MZTmfxlpk1BH1wu3Cs='
WHERE
key_id = '7f4604a36b63b8403d480dc43d1e07f8dfc4d1598a769a5b9aa4b688b4abe9eb'
AND (
token = 'guFLhrLnCG2Rcz3JMh4M4CzO4MZTmfxlpk1BH1wu3Cs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)