UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RXVZnnlPwzyx9kou1wUR1ydK98u4vpfGgSi34tVHvkw='
WHERE
key_id = '7038b6b98e554328a88206e8a15f1bda7e75d31e1b1bdb535971f6a2f3a5ec29'
AND (
token = 'RXVZnnlPwzyx9kou1wUR1ydK98u4vpfGgSi34tVHvkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)