UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J/o7XG4QhhFAtzytYWF46UC7naZB5dW80VT1X9ydKA0='
WHERE
key_id = '7627a558006790ba91ac02d6b2145d579eee7bb4c40cbc7128948785516574f5'
AND (
token = 'J/o7XG4QhhFAtzytYWF46UC7naZB5dW80VT1X9ydKA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)