How can I look up my rotating security code

Open Wallet

Select Apple Card

Tap the card number icon, with the "1 2 3"

You have an Apple Card and an iPhone I presume?

The support article you came here from that describes how to turn on Advanced Fraud Protection has you right in the area where you see the security code. So go there and view the code