UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CglE4Ye3PfqaWt9D62tYSyE+/HhzLLC6Qy7DEsCJzlk=' 
WHERE 
  key_id = '46f0d0b24f1609a65b1822cf33a5547efd175e75767cd4f434bf58b327d9ca8d' 
  AND (
    token = 'CglE4Ye3PfqaWt9D62tYSyE+/HhzLLC6Qy7DEsCJzlk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )