I believe it automatically formats URLs as hyperlinks....but I don't think you can format it to hyperlink under text ("click here"). You can try it with standard HTML < a href = url > text < / a > -- but I don't think that works, tbh.

Try formatting the message to just be "Looks like the wait time is more than 30 minutes, if you would like to log a request instead, please visit https://instance.service-now.com/sp"  and see if they hyperlink works. If not, this may be something you can put in as an "Idea" on Now Support.