UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RAqLaNwkBf9tWfvfwEXDAEVHzFzjavaNvCaosX6tuRI='
WHERE
key_id = '7e8714150adc82d9ad8c8a4b763ec2a9632791f05d86c7af58a0c834ad95b53b'
AND (
token = 'RAqLaNwkBf9tWfvfwEXDAEVHzFzjavaNvCaosX6tuRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)