This thread needs clarification... the feather position does not "override" anything...
In your typical piston twin the oil pressure provided by the prop governor acts to bring the propeller to a flatter pitch (higher rpm). Moving the propeller control to feather directs the prop governor to drop oil pressure to the prob hub, the same as if would happen if you ran out of oil or the oil pump failed (or the engine seized).
Aerodynamic forces normally would act to bring a spinning propeller to flat pitch, however in a piston twin this is counteracted by some combination of springs/air pressure/counterweights, so that the loss of oil pressure brings the propeller to feather.
However, the "feather locks" will lock the propeller in a non-feather position if the prop is stopped or at a very low RPM at the time that the oil pressure loss occurs (be it from actual loss of oil pressure or moving the prop control to feather). These feather locks are actual physical hooks on the blade hubs which drop into place when the prop RPM is very low.
So, when you stop the engine on the ground, the engine stops turning before the oil pressure has a chance to drop significantly, so the feather locks drop into place and prevent the prop from going into feather. This makes the engine easier to start. If you accidentally stop the engine while it is feather ed (or land with the engine feathered), you will have to start the engine to bring it out of feather unless you have an unfeathering accumulator.
If the engine seizes suddenly in the flight the propeller will not feather, nor will it be possible to feather it due to the feather locks. It cannot be "overriden". This doesn't matter, since a stopped prop creates very little drag whether feathered or not.
If oil pressure drops suddenly in flight the propeller will feather, and there's nothing you can do to stop it.
If the engine fails in flight, without losing oil pressure, and you get slow enough that the engine is just "barely" windmilling, then it may not be possible to feather it because of the feather locks. You may have to increase airspeed to bring propeller RPM above the point where the feather locks engage, then feather the propeller.
got it?