How to authenticate user via magic link post stripe checkout?

[iamhenry]

I have been struggling to get authentication to work properly and I'm seeking help

Flow:
user selects a plan -> checkouts via stripe -> send magic link for authentication to protected pages (dashboard) -> signed in to dashboard page

I can see the generated token in the database

but when i click the generated link in my email it doesnt log me in. here are the logs:

any help would be truly appreciated