UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QFC1TX2iHr1tnV3OFCE6kW3phWXpLrfGYr9uX6q77Jo='
WHERE
key_id = '0e8a70f23b568e2cfc74d16bb550a79abe967e99c0b9d11720cc69ef436fafd5'
AND (
token = 'QFC1TX2iHr1tnV3OFCE6kW3phWXpLrfGYr9uX6q77Jo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)