UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TC2NuE2rqwDTufhDhRA24gD8YVBmdY3PMot1ZI4qbdQ='
WHERE
key_id = '4a1e4fc6fe81089d2c7018b26118897dcf1fa90e98e6538c4eae74491affdcd1'
AND (
token = 'TC2NuE2rqwDTufhDhRA24gD8YVBmdY3PMot1ZI4qbdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)