how can i update a value in record when the date/time match the date/time stored in the record itself

I have the following table

my_table

date | time | status

now my first question is: i need to change a status column from zero to one when the date and time match the date and time of the record which is specified by the user when he/she inserted the record.

second question: when user choose date and time he/she will choose it depends on their time zone so how this will effect if the PHPMyAdmin use different time zone ?