A former Paisley priest who committed "horrendous sexual crimes" on two young boys has died in prison.