By definition, final rules cannot be overridden. However, two final rules with the same visible key can arise through importing a ZIP file containing rules, or through other uncommon techniques. Such final rules are conflicts.
As a best practice, eliminate final rule conflicts during development, because the rule not marked final is (incorrectly) never executed.