No, do not use motor oil, WD40, 3-in-one, etc. Here is an oldie but a goodie. It's an excellent article on lubrication overall.
https://www.grantcunningham.com/2006/05/lubrication-101
The lubricant he eventually recommends is now sold by Lubrikit. You can get it here:
https://lubrikit.com/store/index.php...&product_id=54
I've been using it for years now. It is fantastic. It also works well on folding knives and multi-tools.
EDIT: I see that I was not the first to recommend this. The weight of this oil is one of the things I like I about it. I live in a place with big temperature swings and I've never had an issue with the oil.