WD-40 will cool the bit but so would spraying it with water. You need a specific fluid to keep the drill bit & the tp clear of debris.There is no substitute for cutting oil really.
Like this=
https://www.amazon.com/Oatey-30203-Cutting-Threading-16-Ounce/dp/B014CV7C1W