UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0GGMeV7Zh2j3McSXF7pPOvggrt7YYcbuifiRytKw8Yc='
WHERE
key_id = 'c88af79a3ae0039c89716e83918be01f2115a4ba0fd140b0ce40806f4ca119a6'
AND (
token = '0GGMeV7Zh2j3McSXF7pPOvggrt7YYcbuifiRytKw8Yc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)