UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+9cUzNFVIXxTJ+oOoAwIp0bLo5KcYYTTwQSd7Jp8/A4='
WHERE
key_id = '10fdb54303e4d49482fbc88d827011c6c599e0efe90bc0854cb75cb262a86cc5'
AND (
token = '+9cUzNFVIXxTJ+oOoAwIp0bLo5KcYYTTwQSd7Jp8/A4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)