We undergo our Particular Judgement when we die, and then at the end of time there will be the General Judgement - so yes, twice. Though this second judgement does not “overturn” our particular judgement.
From the CCC #
1040 - The Last Judgment will reveal that God’s justice triumphs over all the injustices committed by his creatures and that God’s love is stronger than death.628
Catholic Encyclopedia - General Judgment
Object of the judgment
The judgment will embrace all works, good or bad, forgiven as well as unforgiven
sins, every idle word (
Matthew 12:36), every secret thought (
1 Corinthians 4:5). With the exception of
Peter Lombard,
theologians teach that even the secret
sins of the just will be made manifest, in order that judgment may be made complete and that the
justice and mercy of
God may be glorified. This will not pain or embarrass the
saints, but add to their glory, just as the repentance of St. Peter and
St. Mary Magdalen is to these
saints a source of
joy and
honour.
Form of the judgment
The procedure of the judgment is described in
Matthew 25:31-46, and in the
Apocalypse 20:12. Commentators see in those passages allegorical descriptions intended to convey in a vivid manner the fact that in the last judgment the conduct and
deserts of each individual will be made plain not only to his own
conscience but to the
knowledge of the assembled world. It is probable that no words will be spoken in the judgment, but that in one instant, through a Divine illumination, each creature will thoroughly understand his own
moral condition and that of every fellow creature (
Romans 2:15). Many believe, however, that the words of the sentence: “Come, ye blessed”, etc. and “Depart from me”, etc. will be really addressed by
Christ to the multitude of the saved and the lost.