Depends on how your MyQ is setup. If your MyQ is connected directly through WiFi then it won’t work.
However if you MyQ is setup to use the MyQ Gateway, as long as your gateway is connected to the internet (it uses Ethernet), then yes it’ll work with a Keypad even if your WiFi is down.