UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cS4ZK6wCRCQpt5CRkdOgp6At49cy70ksQzQe8UTGz2A='
WHERE
key_id = '6d40ef3cc7dc74258c2c126f5d6d81e706e978e919ccb11b46cfc770cf32de07'
AND (
token = 'cS4ZK6wCRCQpt5CRkdOgp6At49cy70ksQzQe8UTGz2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)