UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1TZzTUcljClbWLI7LD/S1GF1AnqM7uJeVZlkAgtawt0='
WHERE
key_id = '097764f30dc4295b5813588d055616ccd51de52cd523eee01d3d6f9fb64e5098'
AND (
token = '1TZzTUcljClbWLI7LD/S1GF1AnqM7uJeVZlkAgtawt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)