How to fix the central locking system?

I have a 5 door 1999 Nissan Micra. When I turn the key to lock the doors the doors lock but instantly unlock again, this only happen for the driver's door and back doors. The front passenger door doesn't lock at all. I have to push the internal locking before closing the door to get the 3 doors mentioned locked. However, the other remains unlocked. I tried some DW40 to loosen anything thing jamming, no success. Can you help?