UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WwW69Z9btZux5PwUMgCIWyyyBh10Gc4tTI7vBV5E+Kg='
WHERE
key_id = 'd7fcf99a0fbf066fb56d7e81140b3b3457836872db2a565c190b3a7d5659855a'
AND (
token = 'WwW69Z9btZux5PwUMgCIWyyyBh10Gc4tTI7vBV5E+Kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)