UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z/K32RVkd8hvAK4RvuxJ56LACtcH8EcUJsj3680kvew='
WHERE
key_id = 'd262c558bd9622402b2a1c8c59d97b3e2e7aa9d309bbee0317413de717b4c2de'
AND (
token = 'z/K32RVkd8hvAK4RvuxJ56LACtcH8EcUJsj3680kvew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)