UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/SmH6XZrBKK9/CS5uQHNM297tF9w7wbeKRG6n17gwZ8='
WHERE
key_id = 'f591eca9e72f43217a90d88a2dd5fcc329ee346a1dfe2bca740b4afd60701c0f'
AND (
token = '/SmH6XZrBKK9/CS5uQHNM297tF9w7wbeKRG6n17gwZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)