UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HyVcibQWvtR0g60QdfPJkVUMB0vO0IDmyACsh/2G18c='
WHERE
key_id = '3f80f8a2469dc6905b2751982c57850b3fe1bd60890dfd4afcd6236a4a72d799'
AND (
token = 'HyVcibQWvtR0g60QdfPJkVUMB0vO0IDmyACsh/2G18c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)