UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PHV10GiXtxn8obcFOtuuF910Sn6dSjsGCncqhVB7Sts='
WHERE
key_id = '7899968d6c7f4069fc050d10faf9e2804bab791da4ac2ca44b61e7a2ebf3adbb'
AND (
token = 'PHV10GiXtxn8obcFOtuuF910Sn6dSjsGCncqhVB7Sts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)