Compare sysdate month with a column data
You have not specified the data type of ExpireMonth.  If it is a date or timestamp you can try this

select * from CARDS where EXTRACT(MONTH FROM EXPIREMONTH)  + 1 = EXTRACT(MONTH FROM CURRENT_TIMESTAMP) + 1