UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YU3CAzY8u0y/zLMnhQIa7m8xQlNJ6Swv3g1FoYdG71Y=' 
WHERE 
  key_id = '86d7d9592d5098a9303ac5c752138340c5f5d58bb428dfea2e0ae97224799844' 
  AND (
    token = 'YU3CAzY8u0y/zLMnhQIa7m8xQlNJ6Swv3g1FoYdG71Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035