SELECT c.value
FROM table_c c, table_a a
WHERE c.id IN (9, 17, 25)
AND b.crm_date_time_column >= UNIX_TIMESTAMP(CURDATE())
AND c.id = a.id
GROUP BY c.value

You could do it with query like this. It selects rows from both of the tables, checks if they have same ID and current date is table_a's, crm_date_time_column.
I'm not sure how do you know which rows are linking to each other in your system, so it checks there if they have the same id.