To my knowledge, there is no phrase or word to succintly express the very common, very human, emotion of base desire which will not be acted upon, due to intellectual restrictions. You want to do something, but at the same time do not want to, and will not, do it, because you 'know better'. This conflict of desires happens so frequently in the human experience, it seems like our language is lacking for not offering a concise desription.

Examples of where such a phrase would be apprpriate:
"I don't want to go to work because it is inherently distasteful, but the prospect of theloss of pay/wrath of my boss is more distasteful and makes me want to go."
"I want to eat a gallon of ice cream because I like ice cream a lot, but I am already full and it would make me feel bad physically and emotionally, so I don't really want it."
"I want to have sex with that 15 year old, but it would really piss off my spouse/lover plus I've been socialized to feel like a pervert if I did so, so I don't really want to."

These are cumbersome expressions, but just saying you want, or don't want, something in such a situation is insufficient.