UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KOwA3P+W9HY9vgoou3TQVNonLr0aaafh88ux3wMEwI8=' 
WHERE 
  key_id = '8561b65df1bef463cf8d37fc97435f9e0516e956b6133e79be930a9e136ebfd5' 
  AND (
    token = 'KOwA3P+W9HY9vgoou3TQVNonLr0aaafh88ux3wMEwI8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00010