There are specialized heavy duty sd cards like Kingston industrial, Samsung pro endurance, gigastone mlc, that have MLC memory and are designed for long term storage in extended environment parameters There are also other brands but are less known, more expensive and not available in typical places with consumer electronics

Same applies to SSD drives, there are consumer drives that have colorful boxes with claims like speed or size, and there are specialized SSD drives based on MLC chips that are still available here and there