UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '04kZEeX1ZV4QkwTHXeP2pEmE2+l6XUT3y5EIyaTUyfA=' 
WHERE 
  key_id = '5d308bb0daef73ec2a4be3c8e20ca5fd44a77c803659aad7adf7a7f6c747b231' 
  AND (
    token = '04kZEeX1ZV4QkwTHXeP2pEmE2+l6XUT3y5EIyaTUyfA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00011