Jonny, WD40 is good for cleaning your reel after a session (good for driving moisture / salt water out) but its too thin to use as a lubricant. You need something heavier like Rocket Fuel or EP90 gear oil for the bearings or you risk nesting it big style.
Apparently WD40 is sometimes sprayed on to bait as an attractant, never tried it myself though.