All mortgage foreclosure sales of real property by advertisement under power of sale contained in such mortgages, in which the sheriff's certificate of sale therefor was executed and recorded before January 1, 1992, in the office of the register of deeds of the county, or counties, where the real estate affected thereby is situated, are, notwithstanding any defect or irregularity therein, hereby cured, legalized, and validated.