Etherscan dropped my transaction why

I’m trying to buy my first NFT and I purchased it at a very low gas price. It processed for six hours and now it stopped and the status says “dropped”. I read that you can cancel this but sending yourself 0 ETH with the matching nonce number and I couldn’t even do that. How do I fix this and what should I set a a new gas price to do my transaction will go through?