UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8PQc60PZXREILODO7dwH+VKWJwf4L3krJs+Ou1aFHw='
WHERE
key_id = 'd3bdc4e0836fc796913d63e855c4cbab7461c14fb05923b565f2cdc20c9916b9'
AND (
token = 'N8PQc60PZXREILODO7dwH+VKWJwf4L3krJs+Ou1aFHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)