UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+Mxt6xGhFAmK4Azq/if7HJXLvK0T0aRTKfQStqECQKo=' 
WHERE 
  key_id = 'a1ccf3a4cec5a905da079541449d38a6e88e72bc31d90ee129afc891d4f8ce9f' 
  AND (
    token = '+Mxt6xGhFAmK4Azq/if7HJXLvK0T0aRTKfQStqECQKo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035