The invention discloses a modified unsaturated polyester resin excellent in ageing resistance. The modified unsaturated polyester resin comprises the following raw materials: cis-butenedioic anhydride, phthalic anhydride, maleic anhydride, terephthalic acid, ethylene glycol, propylene glycol, diethylene glycol, rosin, propoxylated bisphenol A, hydroquinone, styrene, linseed oil, cobalt isooctanoate, methyl ethyl ketone peroxide, organic montmorillonite, nano titanium dioxide, nano zinc oxide, an aluminate coupling agent, a polymerization inhibitor, a modified ultraviolet absorber, a catalyst, an air-drying additive and an antioxidant B215. The invention also provides a preparation method of the modified unsaturated polyester resin excellent in ageing resistance. The unsaturated polyester resin prepared by the invention is excellent in ageing resistance.