UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 're8bL9fV27gaq+aOB8u2HWJQgCFkTnOQHfJw851B+Bs=' 
WHERE 
  key_id = '12c7bd3ff098066c34f562022bfe635f283252891876a69e569510196928abe2' 
  AND (
    token = 're8bL9fV27gaq+aOB8u2HWJQgCFkTnOQHfJw851B+Bs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )