Untested solution, just a thought really, but what if 'value' => 'NOW()' so that you avoid having to pass the date, which seems like it’s probably the issue?

EDIT

Alternate solution: Your SQL date format is wrong. It should be $todaysDate = date( 'Y-m-d' ), that should also be the format it is stored in if the row format is DATE or TIME