UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v17RwZub1otTWEIlpbc2LHaUGsNvcO9WymGWO6hK9Uk='
WHERE
key_id = 'c2ca7eeedc80f004d0ad53b3e074ac6a40bb67af858be94d0de44f1a902dac16'
AND (
token = 'v17RwZub1otTWEIlpbc2LHaUGsNvcO9WymGWO6hK9Uk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)