UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ayITuiEkUwzYr7Y00RThmk0SGgbqeqN+vZWf1/t2Pw4='
WHERE
key_id = 'a78d64c3976099078c2609e4e5792333bfb672b732933a77e386539baa552eb7'
AND (
token = 'ayITuiEkUwzYr7Y00RThmk0SGgbqeqN+vZWf1/t2Pw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)