UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jHnSvJW0wwCVZQnQuJNmx2Qal0OF888EkYE2e+3AaFk=' 
WHERE 
  key_id = '1417b582b93154a8ae1a4c603af734da0b4f25f0ec6b1e85fdfca4a292a2895a' 
  AND (
    token = 'jHnSvJW0wwCVZQnQuJNmx2Qal0OF888EkYE2e+3AaFk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )