mysql - SQL Updating TImeStamp To Now() -

mysql - SQL Updating TImeStamp To Now() -

i'm having application checking database expired members.

i'm using:update members set enabled=0 now() >= time

that runs every 30 seconds. first running @ 10 seconds didn't know if issue made 30 seconds instead. that's thing have running , timestamp goes time set , sets time sql command executed. there i'm doing wrong?

isn't expected result? check timestamp compared now() (now() greater time ) , update field. timestamp updated that' s why execution time.

mysql sql