Does it exist: Latching Relay with Manual Switch
If you can't find one, consider the option of having a local switch. Wire it in like you would the light-switches at the top and bottom of a staircase. Whatever the state of the switch at the bottom of the stairs, the switch at the top can always activate and deactivate the light.
Now,.... who knows how to convert it to a local with two remotes?