UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWMkL3/z/tblQLFePBqSCntJuphNdvXLbDBys36izrY='
WHERE
key_id = 'a86563c5242864f0326a210c49e8a655c2e2a40c418b4d5a26cff67c139c0c54'
AND (
token = 'XWMkL3/z/tblQLFePBqSCntJuphNdvXLbDBys36izrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)