So if I'm not mistaken, if I'm really reading this correctly, the Cancel button Cancels the Cancel button? It sounds like it could easily confuse folk.

What is the tone of voice like in your system? I like to use real English as it allows for more precise descriptions, so I'd have something like "Are you sure you want to cancel?" with "Yes, please cancel" and "No, thank you"

Maybe something can be done with the question wording leaving you with a closed question and therefore a boolean. "You are about to cancel this record, are you sure you wish to proceed?" would leave the users with Yes/No options avoiding the word 'Cancel'