UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CDAvSLHEIPMwuahsMNWNWRSki6g/x8xeOx4PNj8sLUU='
WHERE
key_id = '7a25c0766acc75a4ed3c74e90f1c220a43ed5bd0a30e647e93d5e7d641ce3dc0'
AND (
token = 'CDAvSLHEIPMwuahsMNWNWRSki6g/x8xeOx4PNj8sLUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)