UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qD4+/VJRsMQvkK4zw/VTgH4JtjxQ/U0NnF+JrganCcI=' 
WHERE 
  key_id = 'f48d9cfdf6773312066feb8646492830d3499f87ac6c4a8f1209374e6d6a4820' 
  AND (
    token = 'qD4+/VJRsMQvkK4zw/VTgH4JtjxQ/U0NnF+JrganCcI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )