UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RuBWl9yCaPT0h7Mg8YBRzvgK7Ib3oWrikQgjP90We18='
WHERE
key_id = 'e4bd5d5c5b5b965ba201399c21ae5141724d35e9e14fb0a08078064921493ee5'
AND (
token = 'RuBWl9yCaPT0h7Mg8YBRzvgK7Ib3oWrikQgjP90We18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)