What does the beneficiary designation say?
If you want your sister-in-law to succeed to his beneficiary interest in your CD, then you should check the designation to ensure that's the result that will occur. If you don't want that result, then you should probably change the designation.
By...